package org.zh.sh.entity;

public class Student {
    /**
     * 住址-->varchar-->varchar(100)-->-->     */
    public static final String studentAddress = "studentAddress";
    /**
     * 年龄-->tinyint-->tinyint unsigned-->MUL-->     */
    public static final String studentAge = "studentAge";
    /**
     * 出生日期-->datetime-->datetime-->MUL-->     */
    public static final String studentBirthday = "studentBirthday";
    /**
     * 民族-->varchar-->varchar(20)-->-->     */
    public static final String studentEthnicGroup = "studentEthnicGroup";
    /**
     * 性别-->set-->set('男','女')-->MUL-->     */
    public static final String studentGender = "studentGender";
    /**
     * 当前所在班级-->varchar-->varchar(30)-->MUL-->     */
    public static final String studentGradeClass = "studentGradeClass";
    /**
     * 主键ID-->int-->int unsigned-->PRI-->auto_increment     */
    public static final String studentId = "studentId";
    /**
     * 姓名-->varchar-->varchar(20)-->MUL-->     */
    public static final String studentName = "studentName";
    /**
     * 国籍-->varchar-->varchar(20)-->-->     */
    public static final String studentNationality = "studentNationality";
    /**
     * 父母信息情况-->json-->json-->-->     */
    public static final String studentParentsInformation = "studentParentsInformation";
    /**
     * 电话号码-->char-->char(11)-->MUL-->     */
    public static final String studentPhoneNumber = "studentPhoneNumber";

    public static final String tableName = "student";
    public static final String queryById = "select * from student where studentId = ?";
    public static final String deleteById = "delete from student where studentId = ?";
    public static final String updateAll = "update student set studentAddress= ? ,studentAge= ? ,studentBirthday= ? ,studentEthnicGroup= ? ,studentGender= ? ,studentGradeClass= ? ,studentName= ? ,studentNationality= ? ,studentParentsInformation= ? ,studentPhoneNumber= ?  where studentId = ?";
}